////////////////////////////////////////////////////////////////////////////////
// Copyright 2007 CORE Solutions Limited
// All rights reserved.
// PROPRIETARY AND CONFIDENTIAL INFORMATION.
// Use is subject to license terms.
//
// FUNCTION ID      :   POPUP_CATALOG_TREE
// AUTHOR           :   Saint Peng 
// DATE CREATE      :   2007/04/05
// DESCRIPTION      :   a SCHEMA file for the function, POPUP_CATALOG_TREE
//                  :   
//                  :   
//                  :   
//
// MODIFICATION HISTORY:
// DATE         AUTHOR          VERSION NO.         COMMENT
// -----------  --------------  ------------------  -------------------
// 2007/04/05   Saint Peng      1.0                 source is generated.
//
//
//
////////////////////////////////////////////////////////////////////////////////

package com.erp.app.catalog.catalogTreePopup.schema;

import com.erp.framework.model.schema.MetaData;
import com.erp.framework.model.schema.TableSchema;

/**
* <p>A <strong>Schema</strong> stores the table meta information.
* The main purpose for this class is to validate the lengths of UniCode Characters,
* and notify the database to store UniCode characters from web browsers.
*
* @author          Saint Peng 
* @version 1.0     2007/04/05
* @since           FrameWork 1.0
*
*/
public class PopupCatalogTreeSchema extends TableSchema {

	public static final String TABLE_NAME = "T_POPUP_CATALOG_TREE";

	public PopupCatalogTreeSchema(){

		MetaData md = null;

		md = new MetaData();
		md.setColumnName("NODE_ID");
		md.setVoPropertyName("nodeId");
		md.setColumnTitle("NODE_ID");
		md.setColumnTypeName("NUMBER");
		md.setColumnType(2);
		md.setColumnSize(22);
		md.setColumnCatalogName("");
		md.setColumnClassName("com.erp.framework.types.CustomBigInteger");
		md.setColumnPrecision(8);
		md.setColumnScale(0);
		md.setDisplaySize(22);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(0);
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_NODE_ID");
		md.setVoPropertyName("lblSrchNodeId");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_NODE_ID");
		md.setWebLabelName("DEF SRCH NODE ID");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_GRID_NODE_ID");
		md.setVoPropertyName("lblGridNodeId");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_GRID_NODE_ID");
		md.setWebLabelName("DEF GRID NODE ID");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("DESCRIPTION");
		md.setVoPropertyName("description");
		md.setColumnTitle("DESCRIPTION");
		md.setColumnTypeName("VARCHAR2");
		md.setColumnType(12);
		md.setColumnSize(255);
		md.setColumnCatalogName("");
		md.setColumnClassName("java.lang.String");
		md.setColumnPrecision(255);
		md.setColumnScale(0);
		md.setDisplaySize(30);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_DESCRIPTION");
		md.setVoPropertyName("lblSrchDescription");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_DESCRIPTION");
		md.setWebLabelName("DEF SRCH DESCRIPTION");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_GRID_DESCRIPTION");
		md.setVoPropertyName("lblGridDescription");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_GRID_DESCRIPTION");
		md.setWebLabelName("DEF GRID DESCRIPTION");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("CATALOG_LEVEL");
		md.setVoPropertyName("catalogLevel");
		md.setColumnTitle("CATALOG_LEVEL");
		md.setColumnTypeName("NUMBER");
		md.setColumnType(2);
		md.setColumnSize(22);
		md.setColumnCatalogName("");
		md.setColumnClassName("com.erp.framework.types.CustomBigInteger");
		md.setColumnPrecision(5);
		md.setColumnScale(0);
		md.setDisplaySize(22);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_CATALOG_LEVEL");
		md.setVoPropertyName("lblSrchCatalogLevel");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_CATALOG_LEVEL");
		md.setWebLabelName("DEF SRCH CATALOG LEVEL");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_GRID_CATALOG_LEVEL");
		md.setVoPropertyName("lblGridCatalogLevel");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_GRID_CATALOG_LEVEL");
		md.setWebLabelName("DEF GRID CATALOG LEVEL");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("CREATE_COMPANY_CODE");
		md.setVoPropertyName("createCompanyCode");
		md.setColumnTitle("CREATE_COMPANY_CODE");
		md.setColumnTypeName("VARCHAR2");
		md.setColumnType(12);
		md.setColumnSize(35);
		md.setColumnCatalogName("");
		md.setColumnClassName("java.lang.String");
		md.setColumnPrecision(35);
		md.setColumnScale(0);
		md.setDisplaySize(30);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_CREATE_COMPANY_CODE");
		md.setVoPropertyName("lblSrchCreateCompanyCode");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_CREATE_COMPANY_CODE");
		md.setWebLabelName("DEF SRCH CREATE COMPANY CODE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_GRID_CREATE_COMPANY_CODE");
		md.setVoPropertyName("lblGridCreateCompanyCode");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_GRID_CREATE_COMPANY_CODE");
		md.setWebLabelName("DEF GRID CREATE COMPANY CODE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("WATER_MARK");
		md.setVoPropertyName("waterMark");
		md.setColumnTitle("WATER_MARK");
		md.setColumnTypeName("NUMBER");
		md.setColumnType(2);
		md.setColumnSize(22);
		md.setColumnCatalogName("");
		md.setColumnClassName("com.erp.framework.types.CustomBigInteger");
		md.setColumnPrecision(1);
		md.setColumnScale(0);
		md.setDisplaySize(22);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_WATER_MARK");
		md.setVoPropertyName("lblSrchWaterMark");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_WATER_MARK");
		md.setWebLabelName("DEF SRCH WATER MARK");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_GRID_WATER_MARK");
		md.setVoPropertyName("lblGridWaterMark");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_GRID_WATER_MARK");
		md.setWebLabelName("DEF GRID WATER MARK");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("BROWSER");
		md.setVoPropertyName("browser");
		md.setColumnTitle("BROWSER");
		md.setColumnTypeName("NUMBER");
		md.setColumnType(2);
		md.setColumnSize(22);
		md.setColumnCatalogName("");
		md.setColumnClassName("com.erp.framework.types.CustomBigInteger");
		md.setColumnPrecision(1);
		md.setColumnScale(0);
		md.setDisplaySize(22);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_BROWSER");
		md.setVoPropertyName("lblSrchBrowser");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_BROWSER");
		md.setWebLabelName("DEF SRCH BROWSER");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_GRID_BROWSER");
		md.setVoPropertyName("lblGridBrowser");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_GRID_BROWSER");
		md.setWebLabelName("DEF GRID BROWSER");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LEVEL_1_NODE_ID");
		md.setVoPropertyName("level1NodeId");
		md.setColumnTitle("LEVEL_1_NODE_ID");
		md.setColumnTypeName("NUMBER");
		md.setColumnType(2);
		md.setColumnSize(22);
		md.setColumnCatalogName("");
		md.setColumnClassName("com.erp.framework.types.CustomBigInteger");
		md.setColumnPrecision(8);
		md.setColumnScale(0);
		md.setDisplaySize(22);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_LEVEL_1_NODE_ID");
		md.setVoPropertyName("lblSrchLevel1NodeId");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_LEVEL_1_NODE_ID");
		md.setWebLabelName("DEF SRCH LEVEL 1 NODE ID");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_GRID_LEVEL_1_NODE_ID");
		md.setVoPropertyName("lblGridLevel1NodeId");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_GRID_LEVEL_1_NODE_ID");
		md.setWebLabelName("DEF GRID LEVEL 1 NODE ID");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LEVEL_2_NODE_ID");
		md.setVoPropertyName("level2NodeId");
		md.setColumnTitle("LEVEL_2_NODE_ID");
		md.setColumnTypeName("NUMBER");
		md.setColumnType(2);
		md.setColumnSize(22);
		md.setColumnCatalogName("");
		md.setColumnClassName("com.erp.framework.types.CustomBigInteger");
		md.setColumnPrecision(8);
		md.setColumnScale(0);
		md.setDisplaySize(22);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_LEVEL_2_NODE_ID");
		md.setVoPropertyName("lblSrchLevel2NodeId");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_LEVEL_2_NODE_ID");
		md.setWebLabelName("DEF SRCH LEVEL 2 NODE ID");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_GRID_LEVEL_2_NODE_ID");
		md.setVoPropertyName("lblGridLevel2NodeId");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_GRID_LEVEL_2_NODE_ID");
		md.setWebLabelName("DEF GRID LEVEL 2 NODE ID");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LEVEL_3_NODE_ID");
		md.setVoPropertyName("level3NodeId");
		md.setColumnTitle("LEVEL_3_NODE_ID");
		md.setColumnTypeName("NUMBER");
		md.setColumnType(2);
		md.setColumnSize(22);
		md.setColumnCatalogName("");
		md.setColumnClassName("com.erp.framework.types.CustomBigInteger");
		md.setColumnPrecision(8);
		md.setColumnScale(0);
		md.setDisplaySize(22);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_LEVEL_3_NODE_ID");
		md.setVoPropertyName("lblSrchLevel3NodeId");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_LEVEL_3_NODE_ID");
		md.setWebLabelName("DEF SRCH LEVEL 3 NODE ID");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_GRID_LEVEL_3_NODE_ID");
		md.setVoPropertyName("lblGridLevel3NodeId");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_GRID_LEVEL_3_NODE_ID");
		md.setWebLabelName("DEF GRID LEVEL 3 NODE ID");
		ts.add(md);

		md = new MetaData();
		md.setWebObjectId("LBL_GRID_SELECT");
		md.setWebLabelName("DEF GRID SELECT");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		ts.add(md);

		md = new MetaData();
		md.setWebObjectId("LBL_GRID_DELETE");
		md.setWebLabelName("DEF GRID DELETE");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		ts.add(md);

		md = new MetaData();
		md.setWebObjectId("LBL_MOD_NAME");
		md.setWebLabelName("DEF MOD NAME");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		ts.add(md);

		md = new MetaData();
		md.setWebObjectId("LBL_SRCH_FROM");
		md.setWebLabelName("DEF SRCH FROM");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		ts.add(md);

		md = new MetaData();
		md.setWebObjectId("LBL_SRCH_TO");
		md.setWebLabelName("DEF SRCH TO");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		ts.add(md);
		
		md = new MetaData();
		md.setColumnName("PARENT_NODE_ID");
		md.setVoPropertyName("parentNodeId");
		md.setColumnTitle("PARENT_NODE_ID");
		md.setColumnTypeName("NUMBER");
		md.setColumnType(2);
		md.setColumnSize(22);
		md.setColumnCatalogName("");
		md.setColumnClassName("com.erp.framework.types.CustomBigInteger");
		md.setColumnPrecision(8);
		md.setColumnScale(0);
		md.setDisplaySize(22);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(0);
		ts.add(md);
		
		md = new MetaData();
		md.setColumnName("LBL_GRID_PARENT_NODE_ID");
		md.setVoPropertyName("lblGridParentNodeId");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_GRID_PARENT_NODE_ID");
		md.setWebLabelName("DEF GRID PARENT NODE ID");
		ts.add(md);

		new PopupCatalogTreeCommonSchema().setMoreSchema(ts);
	}

}